﻿CREATE FUNCTION [dbo].[clr_VerifyStreet]
(@zip NVARCHAR (4000), @street NVARCHAR (4000), @city NVARCHAR (4000), @state NVARCHAR (4000))
RETURNS 
     TABLE (
        [FirstName] NVARCHAR (64) NULL,
        [LastName]  NVARCHAR (64) NULL,
        [Street]    NVARCHAR (64) NULL,
        [City]      NVARCHAR (64) NULL,
        [State]     NVARCHAR (2)  NULL,
        [Zip]       NVARCHAR (10) NULL,
        [Country]   NVARCHAR (2)  NULL)
AS
 EXTERNAL NAME [Library].[UserDefinedFunctions].[clr_VerifyStreet]


GO
EXECUTE sp_addextendedproperty @name = N'AutoDeployed', @value = N'yes', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'FUNCTION', @level1name = N'clr_VerifyStreet';


GO
EXECUTE sp_addextendedproperty @name = N'SqlAssemblyFile', @value = N'Rate.cs', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'FUNCTION', @level1name = N'clr_VerifyStreet';


GO
EXECUTE sp_addextendedproperty @name = N'SqlAssemblyFileLine', @value = 21, @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'FUNCTION', @level1name = N'clr_VerifyStreet';

